Re: CURSORs and selects with parameters

Поиск
Список
Период
Сортировка
От Dan Sugalski
Тема Re: CURSORs and selects with parameters
Дата
Msg-id a06210206be3803ced192@[172.24.18.155]
обсуждение исходный текст
Ответ на Re: CURSORs and selects with parameters  (Michael Fuhr <mike@fuhr.org>)
Ответы Schema comparison tool  (Jeff Amiel <jamiel@istreamimaging.com>)
Список pgsql-general
At 12:50 PM -0700 2/15/05, Michael Fuhr wrote:
>On Tue, Feb 15, 2005 at 02:32:56PM -0500, Dan Sugalski wrote:
>>
>>  I've got some code that uses PQexecParams and does the equivalent of:
>>
>>     DECLARE a_cursor CURSOR FOR SELECT foo, bar FROM baz WHERE field = $1
>>     FETCH NEXT a_cursor
>>
>>  but when I get to the FETCH I'm getting back the error:
>>
>>     ERROR:  no value found for parameter 1
>
>What version of PostgreSQL are you using?

I'm using 7.4.5.

>  I think this is fixed
>in 8.0.
>
>http://archives.postgresql.org/pgsql-general/2005-01/msg00812.php

D'oh! Missed that one in the search. Time to find some upgrade
packages, then. Thanks.
--
                Dan

--------------------------------------it's like this-------------------
Dan Sugalski                          even samurai
dan@sidhe.org                         have teddy bears and even
                                       teddy bears get drunk

В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: CURSORs and selects with parameters
Следующее
От: Christopher Browne
Дата:
Сообщение: Re: Slony uninstall info/warning